﻿//
// Copyright (c) 2011 Canyala Innovation AB
//
// Permission is hereby granted, free of charge, to any person obtaining a copy of this software and 
// associated documentation files (the "Software"), to deal in the Software without restriction, including
// without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell 
// copies of the Software, and to permit persons to whom the Software is furnished to do so, 
// subject to the following conditions:
//
// The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
//
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT 
// NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. 
// IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, 
// WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH 
// THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. 
//

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using Canyala.Lagoon.Extensions;
using Canyala.Lagoon.Database;

namespace Canyala.Lagoon.Sample.Database
{
    public class Person : IdentityRecord
    {
        public DateTime DateOfBirth { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public int NumberOfCars { get; set; }
    }

    public class PersonName
    {
        public string FirstName { get; set; }
        public string LastName { get; set; }
    }

    class Program
    {
        const string ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=SocialNetwork;Integrated Security=True;Pooling=False";

        static void Main(string[] args)
        {
            var records = ActiveRecord.FromConnectionString(ConnectionString);

            records.Delete<Person>();

            for (int numberOfCars = 0; numberOfCars < 100; numberOfCars++)
            {
                records.Insert(
                    new Person
                    {
                        Id = Guid.NewGuid(),
                        FirstName = "Brian" + numberOfCars,
                        LastName = "Johnsson" + numberOfCars,
                        DateOfBirth = DateTime.UtcNow,
                        NumberOfCars = numberOfCars
                    }
                );
            }

            records
                .Select<Person>(where: record => record.FirstName.EndsWith("2"), orderBy: record => record.NumberOfCars, sort:Sort.Ascending, skip: 1, take: 5)
                .Do(Print);
        }

        static void Print(object instance)
        {
            var formattedList = instance
                .GetType()
                .GetSemanticProperties()
                .Select(property => String.Concat(property.Name, ":", instance.GetPropertyValue(property)))
                .Join(", ");

            Console.WriteLine(String.Concat("{ ", formattedList, " }"));
        }
    }
}
